SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019300 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019300 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459691,660246,822324,247054,843070,874738,274782,247041,104611,1042697,649620,511875,471312,891023,715061,915181,738596,620175,537692,559829,1009597,767669,831543,798519,172386,425241,424814,866900,1000710,856993,56574,482535,967301,713325,601416,513068,158285,392795,403286,945178,556232,57767,946256,127661,648101,847284,49427,451205,891430,71051,372673,33760,773509,52063,731980,643388,331770,21932,396252,549223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]