SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191343 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191343 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034863,1018480,96085,598818,947654,1005194,975857,925895,288870,358816,469379,594231,321411,1041865,521485,19627,979717,1025270,345616,157881,461615,524552,395044,678324,670461,346600,843473,536444,435140,209149,665036,997679,416934,617702,60974,717030,787847,265132,672438,721253,468521,573618,118418,195595,57009,846307,324279,643860,422464,999515,754419,347776,137862,392346,15527,809253,138909,22300,484042,164759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]