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` = 480371 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480371 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689802,147105,49527,411656,364565,211846,450010,726131,118242,812463,280595,785417,912739,138578,200680,775782,935700,272601,535842,779823,868081,450860,562099,354425,705371,989397,209774,454232,388028,404531,853795,910343,354655,663802,562732,669578,683283,376910,118415,149271,890728,890818,205501,625979,681478,796678,899965,889741,616526,636589,571510,1008262,984888,590400,1031628,52961,78828,162129,511693,368843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001796s ]