SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412240 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412240 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278473,784609,265861,438558,449375,182456,351176,113625,871628,635554,872154,677580,952277,950179,634285,380434,628946,986006,295831,162930,219051,430168,698756,493686,521020,333488,869928,659043,417160,310387,601718,55173,528436,1001570,859630,927562,559029,213715,32600,437842,252911,218495,101165,439154,127695,423998,680999,637265,344360,1014291,146932,572936,963959,514865,523220,254204,385997,456035,766915,697460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]