SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510601 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510601 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228602,704773,458361,651624,1020694,302360,341980,545563,355176,166232,421642,421139,194624,549325,876816,979009,10306,194732,1004388,1028393,549566,467885,31437,564265,652411,611096,481712,839342,4947,939533,383554,387837,701307,927112,47296,996259,381316,89770,777537,94186,249290,229313,813964,735985,370396,682434,489183,477579,408560,776550,1046642,482803,284584,522380,317571,860431,660104,113083,728675,641825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]