SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529916 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529916 [ RunTime:0.003889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261047,1017368,592618,533474,196424,636176,275569,715225,544534,853674,114501,1034324,594642,952326,720901,511357,644122,903974,889965,576396,149082,217727,188877,288686,1027797,919201,348580,668816,994298,101460,491213,639419,929493,641876,1033786,861950,123942,195497,296762,629106,163104,236404,865705,647757,476868,126556,566195,944456,883015,348455,46390,563982,1016622,332529,971833,123969,643190,597559,338835,159058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]