SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418721 LIMIT 1 [ RunTime:0.001582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418721 [ RunTime:0.007860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568776,892710,527602,887159,410090,392948,64842,798153,571079,818561,442608,401076,908946,899610,784566,502967,15340,46645,662959,865108,294432,495526,527915,737090,898469,600394,811999,1044508,202509,768293,376330,669587,193427,872672,789788,378311,222905,728789,283161,116185,304562,456121,476113,772446,121354,83251,474940,989682,987715,163245,98146,1041415,496315,869106,781816,1030077,320553,235965,232158,739845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]