SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046536 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046536 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587982,252383,390917,566564,994535,793756,593346,960854,795614,12982,133982,233140,502688,869119,654436,16626,803846,856239,356016,439181,436395,52621,16751,963567,436356,923722,984611,434777,14325,206473,1025795,511934,477925,24395,122103,680998,79503,280158,674931,963991,297600,803774,1011128,540960,947049,512008,771836,260560,302263,667189,461941,803297,1014247,783251,563563,533966,967443,435494,976660,530177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]