SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432313 LIMIT 1 [ RunTime:0.005898s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432313 [ RunTime:0.009619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594518,100257,858346,697490,88221,487745,160510,695634,50543,312243,209862,2013,861086,230901,273376,207180,116982,898489,660677,71634,901174,387026,908801,613051,621008,305944,530609,289096,217222,732931,494177,743932,15867,590481,460313,669626,435382,487721,179477,169401,353894,552973,536884,195657,722277,347659,276686,551342,886088,958484,728565,732074,27740,1019372,795606,420348,570341,265694,994508,224190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003620s ]