SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540745 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540745 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670086,840397,1011160,33613,830039,291280,947865,33983,725030,987133,499245,507532,554174,388898,675379,421955,832160,142456,175442,526262,988759,695024,473101,12988,156560,682086,395903,326651,101294,1027674,1043936,52769,903043,237314,1008238,167337,474213,404651,102488,99192,449735,816719,453587,735523,704556,625139,173671,583348,549720,289200,824035,355613,464522,218721,983233,964144,1042269,270443,304190,936426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540745 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540745 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]