SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387341 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387341 [ RunTime:0.003620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417181,952041,131655,60022,153268,536405,840152,103622,277051,930313,76293,138581,901243,785549,476702,292382,571017,310418,570378,38449,213442,860250,531754,793567,606818,697282,534958,989541,21575,844523,790939,693440,34399,798926,798150,224159,987572,894691,383854,579407,878509,752483,601729,13469,639796,1023672,254103,749059,92714,185002,838900,536935,36584,862241,285133,997681,943370,639862,341807,530976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]