SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306808 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306808 [ RunTime:0.002694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510158,646173,619154,245351,35209,478291,645947,864043,1031588,685944,550117,851791,990115,166152,834511,199570,567223,29628,438978,571012,1029883,19801,672111,802914,760306,366354,942694,337439,1010690,723766,106452,105301,1009515,742009,928524,592788,460302,267076,546784,368867,847871,134435,338208,9899,306007,543272,272679,277829,194264,111266,613157,785037,193217,1011470,37796,575861,432412,751362,248054,697749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]