SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581391 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581391 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892330,806244,479190,480624,629883,786381,1046209,890468,678504,115663,948887,924233,339930,803197,737759,60354,812066,382142,83130,412043,122162,229179,290984,386711,1035682,850393,416398,792582,615011,584960,47328,185457,61435,398857,174739,319701,998553,724833,633989,780060,955717,366865,260437,352869,879073,373913,948732,209913,627194,218529,802624,397468,794483,615592,849242,475308,748877,852035,932653,1005915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]