SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426310 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426310 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915500,977115,230326,1037003,600846,222885,1023725,577145,37314,639109,720245,15551,627252,237132,436756,480508,361778,730742,159913,932779,475945,329093,1015139,654697,911768,317776,682541,873584,422682,151512,665550,142303,219370,590263,236378,1000007,307160,337442,58387,826376,220567,406701,1026997,895730,220828,956351,208931,367267,247940,378473,1031418,780937,149557,475857,124640,1021506,70044,219625,487817,152106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001859s ]