SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45815 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45815 [ RunTime:0.002476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597476,114491,379179,461466,836583,628243,947643,772958,395232,8284,848732,818823,35981,368770,604212,102999,212175,661389,1043717,1039764,989774,720162,251947,449784,7761,466352,340546,125539,210065,83143,333564,615219,494265,294943,530745,611981,948175,784012,30788,64540,1025506,463107,587853,688544,923213,733496,491685,326775,153327,545351,416697,114716,687936,1027981,223654,145043,754697,515011,462041,215434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]