SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356599 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356599 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988104,477162,249135,819702,1020184,440617,645201,345852,655277,743099,679592,118758,557611,332584,736584,752130,696952,26199,503794,798969,98718,985171,396995,55854,432898,790432,880227,434233,579233,144379,872282,476492,889193,897060,1021133,121399,191627,145769,805819,694184,595238,301332,975060,185286,785817,227841,64426,739808,169930,485086,999407,80687,740974,246170,365226,936889,160726,41417,82339,271312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]