SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434406 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434406 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305739,147098,810001,596431,491170,351150,155911,1018362,24812,217461,24342,1015782,999982,932834,1029164,181170,737064,907259,625656,960184,501387,42291,919590,110798,72933,875950,612863,213039,725053,184013,263073,225931,1040189,782905,499959,457597,420013,653932,1045206,1020098,693172,689759,780690,719516,761392,612707,983082,105937,1014019,176612,954488,329182,566758,443271,1024824,341591,928809,48703,844357,168416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005047s ]