SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299580 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299580 [ RunTime:0.002780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682661,678796,115312,281552,752171,433979,512163,854422,240265,325719,1016331,447364,219227,73415,343808,251978,40546,101239,633569,298676,329662,1004297,398704,348668,378179,270374,724211,459523,847718,564956,634787,354289,508399,962907,716234,1033746,104646,38854,868079,738538,548686,898638,26381,801936,146372,305414,234318,507800,521425,306201,946309,281742,1046238,246490,455679,463927,659072,632229,425972,756090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]