SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003685s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412903 LIMIT 1 [ RunTime:0.000566s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412903 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567839,91846,620453,588373,241207,890657,42527,195009,526886,479726,819402,450574,666345,823882,63402,131667,500384,103925,966409,219780,703778,323015,390163,201704,351767,992935,955829,226404,924034,3690,280725,97382,477508,398876,448191,544466,136941,24518,944685,444633,880224,481641,711932,82025,338983,295903,785743,685852,662003,19048,738701,308177,573838,739309,345868,180636,447123,132101,554119,504137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001737s ]