SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442654 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442654 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177922,49727,847964,637500,52962,544386,924137,1034611,589802,978691,110337,49384,988541,224446,201310,675234,488192,1038732,880400,33733,944946,388261,262688,681663,574309,572452,562391,366181,872519,153978,753447,424154,76383,23486,23202,551552,887269,960864,529814,997236,157156,582554,655829,170614,865280,905016,416066,344006,562380,205805,207124,506839,844610,805957,863483,905452,469064,563207,460643,249651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001271s ]