SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404268 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404268 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128689,781349,579580,598157,323741,156354,684820,143177,918219,642233,630838,1034822,1023765,417829,16577,603354,331687,92225,773886,712914,163362,356374,1034939,10983,145788,739629,1046538,382205,458194,675875,580322,968296,1015089,452516,455408,394894,130761,214211,940129,433858,510752,369666,275002,419860,806805,595295,966393,580645,287097,451051,89438,925733,980561,489713,389912,457428,167010,935930,412153,405001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]