SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489916 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489916 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392210,374524,194487,1022597,698767,865700,19167,406733,174938,443778,784368,997129,528285,176769,154569,16574,600084,714768,488214,1003367,8390,587993,284440,909555,829243,632604,376608,647432,124468,656447,904340,193814,28759,178273,868791,388931,435580,677932,718953,53429,527163,651841,231623,212815,888096,834988,167141,410237,916616,93116,196356,150784,928196,799438,136888,276627,713722,1024274,974063,614438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]