SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583613 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583613 [ RunTime:0.002456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759150,765571,840157,107874,23866,893205,271649,235445,314986,362141,222727,112991,975230,900584,90680,374895,56680,874645,830820,136298,378312,349634,923203,464949,704293,999743,866569,143165,752693,354792,621477,127360,376263,338511,487087,302536,684360,616839,850904,1046077,492679,1036331,244478,42429,262399,83498,59742,480575,973795,440733,1044031,607452,918199,225342,1016136,48673,187553,398320,271801,568930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001170s ]