SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010396 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010396 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62177,585401,741674,51398,54902,875004,761595,465775,370279,415775,652438,100148,284075,328702,125792,734227,603071,723056,761156,482597,947281,613991,649607,374932,891789,102489,675513,525983,683923,452783,228555,977442,801488,33079,571109,698724,905689,824853,807841,349996,361551,588013,652846,805438,413646,259938,826120,956870,413672,784018,41321,835072,916925,900841,801643,140326,685949,623608,279375,805219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]