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` = 544875 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544875 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620854,422930,885665,677641,432556,819865,251712,1033455,295565,730244,909963,385747,683984,904837,809726,88199,694789,312833,612900,641881,957339,257492,1030051,755333,451880,440456,570139,690718,80179,458188,150440,790249,789230,696892,88469,502061,674206,170288,148086,943485,833099,332232,516480,692793,411534,588368,33440,400154,652180,206170,202423,975945,267664,117538,479977,494625,846548,209328,973755,663844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]