SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508401 LIMIT 1 [ RunTime:0.001418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508401 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847063,1017657,632291,860871,566112,555619,206381,596476,357184,1006800,698760,844793,262166,638979,212485,751971,83164,401239,365608,525128,583997,208303,1015840,637497,1015350,975457,48659,151407,552563,623533,149842,77860,999120,631613,600281,239289,202256,834124,852572,966095,508154,745723,548929,589090,557865,570964,873308,251498,746869,137628,67057,516596,141047,477979,168870,248726,907847,818742,241401,192597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]