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` = 1028606 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028606 [ RunTime:0.003087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702654,1009890,900879,228415,800753,994197,211176,189326,375192,206375,489718,487053,657331,425995,491104,1004878,145705,463838,107560,482822,344036,809946,542574,612570,185069,197218,386018,906522,883632,974424,322135,559473,941912,195344,83427,682264,497225,725561,464449,188580,216423,502452,611697,922680,108163,934615,394907,506247,1002100,852207,161704,1040665,231284,755541,245138,823211,188819,853186,528217,76794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]