SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459211 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459211 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934925,103768,705024,406523,807161,158791,887740,242686,524445,307958,455606,543749,891076,952326,42417,371982,938842,407285,932102,880368,147902,244723,880582,716779,745541,964850,221837,169093,805945,854118,814367,711588,152225,589302,275929,977400,1034225,125805,1036417,47890,266076,298639,765812,233844,920341,460270,645941,173521,191672,527526,603317,363528,430934,752326,763594,350137,341160,976662,640266,263026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]