SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195438 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195438 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451044,752616,494750,650707,486555,984074,700717,309679,790804,1016873,579665,855826,106373,811191,107474,461078,390251,936173,389431,1047748,274269,1029473,838756,115144,390946,677911,929609,128970,248743,326159,412253,31191,285935,1030493,546484,377410,693972,459903,95744,693731,575002,529991,880568,677268,937347,525748,783547,867305,1029590,870020,997735,542034,1024254,31256,397204,698768,461060,111208,4560,425853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]