SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514509 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514509 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311561,478789,139499,814127,759001,957430,407313,11168,45840,267666,150537,460837,769546,512879,106926,865488,1032859,228762,893737,602515,638361,391754,1020788,358995,778882,385533,992,664670,240015,570594,278571,554275,792073,664303,437110,776019,20248,582502,920016,903649,89455,469150,616779,611125,229564,866500,302004,1024752,1040458,726624,384713,556892,491263,902002,286690,100732,583590,332474,751567,63022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]