SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034489 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034489 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403995,252992,667990,931278,631956,842894,785183,984890,140807,407232,118096,1207,877039,935054,129044,330485,136665,616453,700695,938899,207300,601659,260997,341401,1040940,497193,609891,278440,240148,59877,192220,672385,1016894,562113,1035288,449010,740747,314190,1048748,570347,107001,564545,787741,1001438,800316,651675,339479,374861,614063,416013,85533,711835,161449,651254,396055,738395,574973,427720,201675,142929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]