SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250014 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250014 [ RunTime:0.003340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042856,834570,141631,202110,246636,216121,705957,90621,715918,747378,956635,443007,450401,1015169,300682,1032830,706296,1015161,175811,182124,319050,844051,891009,315209,588589,951353,956551,293537,365473,1040550,839154,869698,463504,8605,705384,911294,17207,617171,460936,681595,107791,1020885,306931,154140,495348,717566,907363,733469,401435,1048722,1029165,541524,899793,282660,521411,809795,480286,313897,252168,938953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]