SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005707 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005707 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380841,459114,880049,654973,25144,997288,503848,1036747,330571,108109,170216,234115,118723,159908,975884,245385,1000900,684430,332936,302828,356667,381802,336419,1044502,701806,708603,338379,791880,925919,371316,585899,318443,87249,825511,156396,151571,284736,803670,80845,885189,922783,747780,113621,17709,520342,391599,900517,62652,572748,33397,698676,276628,183157,457320,817406,484977,327735,721180,528303,469369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]