SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001902s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501176 LIMIT 1 [ RunTime:0.001835s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501176 [ RunTime:0.004762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758594,170503,216305,254005,106344,721633,574890,359644,1038079,813508,942136,940938,605937,73100,428036,97393,948377,653853,729630,314577,266257,295565,717107,1025028,796249,885223,474502,116019,855108,740300,839679,206568,985364,660536,754168,154067,405995,894397,853901,638401,344889,884493,139274,147917,651223,510849,1017167,63934,146704,110281,496751,755131,316300,572600,663776,580848,542072,81093,971910,130014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004240s ]