SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483503 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483503 [ RunTime:0.002819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100060,140500,201289,952587,671271,729351,410770,336452,436652,163304,771190,741904,880707,134455,358017,766976,906892,362797,916337,635888,754433,872496,965554,630839,256226,839807,56417,289752,336871,778797,173554,367548,558846,332769,593670,1009592,801422,706475,973395,436046,130355,1012417,636058,660668,403460,391433,1036083,506525,242299,543878,543611,645288,804902,862642,733400,594368,413526,101801,497213,861577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000968s ]