SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403047 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403047 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274975,43568,1035499,436980,466610,276837,889556,412876,520793,508121,952226,507974,403244,206940,629484,201291,295225,90585,342090,854199,450484,130468,611126,170773,944145,120584,1018774,493053,609748,1043298,647884,75621,938629,89236,444522,800243,881740,516141,120696,456692,192183,1018459,1024230,449806,378842,429819,432638,496849,120615,31736,280155,294543,343629,780924,92883,451531,522224,690317,241116,170161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]