SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 81998 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 81998 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849797,382821,337785,450355,878799,920714,592780,406845,260251,19904,388318,952288,854878,473059,7740,73324,898906,783710,643046,34013,97550,513653,919197,1009184,373355,1009254,663109,356637,115129,120062,400782,797969,382981,949985,792950,421236,553968,484533,61221,26821,569771,885551,504335,150567,371536,4001,985788,16692,407977,696851,578410,663740,996560,184200,671291,178021,450577,993092,946732,239309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 81998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 81998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]