SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302001 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302001 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21224,675721,583130,90763,813336,781213,480352,921709,9395,363288,494529,632068,502201,619609,763786,720642,1004939,107979,119272,35301,551108,367888,591383,882371,853204,759390,975633,389447,656782,595847,958071,461249,209372,13634,427207,348397,451077,985629,723103,951577,874629,209827,264513,964719,867397,457692,178912,462599,151903,673451,480269,670102,885556,400932,65336,851726,502513,389290,918130,308535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]