SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269894 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269894 [ RunTime:0.001246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292257,472103,692474,984596,496679,1040929,818979,393722,150091,195328,190277,780320,872362,373309,306941,485760,340416,414100,944553,622971,382033,880392,604188,920164,4935,507991,203300,530788,105649,195299,748065,583763,849257,913405,533498,313060,708136,486798,71592,515492,882924,229144,681599,37662,439889,235005,331344,657658,913079,916732,649160,562563,301000,237875,509567,492190,458553,353993,526418,34410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]