SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002011s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541393 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541393 [ RunTime:0.001314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336650,693858,638709,492808,840824,498842,226094,23279,1001140,583315,111499,1028749,830815,594211,661344,193214,321652,497221,440667,969923,518220,956654,552674,20230,603768,317595,377585,368452,623869,49003,16057,684069,799515,442023,868454,194168,539083,892334,863208,60605,608625,596609,343588,29984,856292,116892,784561,98555,157954,197468,348241,762569,494549,891367,680689,400412,577183,381768,772842,8433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]