SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103544 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103544 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26916,812175,335707,176473,152440,567029,578041,676378,847879,267018,826265,101913,524042,157808,776230,198577,4112,901644,234404,467157,1024154,270702,474997,142901,913663,792511,108604,979504,517567,634318,656358,152452,186419,483023,573844,383090,821138,404561,69842,149484,4333,65572,638592,415558,912758,205187,653296,364382,181955,411914,629262,912820,947466,651457,611166,1027347,148071,210851,481438,745920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000853s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002361s ]