SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002745s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349718 LIMIT 1 [ RunTime:0.002526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349718 [ RunTime:0.004404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192752,114785,712008,380032,932734,112260,160073,52927,306394,416368,220039,971041,934489,657361,329037,389728,1015951,370281,492704,351209,636884,563322,893388,745544,949653,521480,41642,761450,220264,304948,905790,378072,925632,78435,146658,206328,88497,891083,388922,598004,658160,1032622,886304,762638,907407,744582,135177,115355,40019,20425,514473,535518,191928,609433,980798,15975,620879,211064,307233,825978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]