SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437272 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437272 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767227,602302,731456,179774,130004,750737,209286,772104,1020783,403443,107569,685187,1024757,386298,670954,1015941,613678,468729,468843,414846,522009,483908,366656,670,971147,429294,223424,925144,793865,565263,931487,128914,72874,657460,474643,247892,118361,362601,278291,289614,232081,798136,809515,73458,187782,548096,444786,765663,779319,747185,675840,857426,389600,276315,483666,1038720,197926,127043,273051,944058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]