SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411180 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411180 [ RunTime:0.001300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141856,309281,789434,829858,94333,924024,898609,1025669,836573,503372,570027,899178,557373,836433,706729,777806,799357,660494,327652,860097,476060,110302,247686,244013,651601,716281,398546,392547,518878,502019,161190,1022694,926502,1022552,551749,65580,14985,259787,174159,698298,251354,418274,159378,1009692,999289,871615,717043,456972,134411,161793,371911,254700,384806,768084,647079,513817,691448,914596,488493,302998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]