SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433915 LIMIT 1 [ RunTime:0.000989s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433915 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861249,803781,895799,327948,560614,970175,323324,589127,464784,594237,944073,104236,638690,456337,880852,246659,796628,239333,734723,328997,980730,360137,686469,199299,478409,284272,258184,274610,368202,763450,514933,240799,733393,70837,109916,1014539,815198,825967,439098,251188,76792,743529,424899,754932,564635,164210,324255,679698,53237,637017,81150,592449,451349,617045,380011,538763,314965,144628,816291,847099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]