SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003672s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452753 LIMIT 1 [ RunTime:0.002163s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452753 [ RunTime:0.006145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38705,787652,508300,64561,950882,866030,203943,839524,469406,570050,216798,44420,781627,994140,1046841,857074,391180,985544,554760,1019334,447474,349184,644040,30384,658678,451535,22801,709709,960683,792864,141269,1026154,290641,277812,68307,292827,1003129,689573,91435,476873,139933,885269,58892,521290,164491,999658,1017037,1003408,149658,220381,1028052,616215,285876,156092,986529,900516,460675,376001,264290,787373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003115s ]