SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 219113 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 219113 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422523,991301,637123,183618,522767,513624,405377,866179,793503,598165,458307,85685,817820,818132,1040520,947369,446299,576997,190370,872960,505393,65285,60320,645415,974596,865108,306560,1033153,313959,574948,348172,696348,445118,192712,370640,414501,599906,634359,908195,852585,348828,727812,1034887,336533,511134,958033,396091,189727,781027,423986,1016806,846236,163816,922199,874793,341237,975377,965495,577447,93215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 219113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 219113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]