SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318711 LIMIT 1 [ RunTime:0.001374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318711 [ RunTime:0.001335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420226,395045,158735,818327,8002,693210,1006172,492293,697975,713339,354681,644548,124487,832897,524816,242731,401341,391078,908196,686572,228326,276570,687715,501035,821949,281298,92528,448832,876489,930896,28257,741683,808152,538580,684817,916655,954851,937386,916112,661544,992738,364249,181266,718326,568127,404297,960641,371157,129813,523572,533090,782884,898494,331764,73223,600968,732076,32273,731052,650404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003620s ]