SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267016 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267016 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116248,461648,867629,866284,371936,405782,239926,400376,283420,1038339,600272,440378,71787,984213,662898,589306,146286,548406,359184,140152,847446,567162,724128,510089,989447,450949,702804,619521,1042847,301199,665459,684641,698099,433200,975200,758763,149874,557981,540932,687348,366778,463657,245737,231987,637060,1001855,450326,417669,993089,987950,29194,433961,745579,262712,422767,916058,344422,791554,58380,894565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]