SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804512 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804512 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335483,811375,213891,312363,1035608,558755,360644,86655,944813,723411,150181,479904,461963,515747,626440,53654,674954,520176,688478,484369,166380,175935,429697,193623,336626,341688,75521,975573,944495,40580,518928,339549,237948,575175,707813,506819,662112,614423,122327,867542,764956,748680,915653,565492,169999,1003369,608357,1008786,90078,583092,336201,855758,877890,396820,641633,622088,854909,362188,821701,389987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]