SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532720 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532720 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212918,373001,88924,902593,214341,852814,455153,905344,15752,787412,543531,298095,388721,972264,359711,981797,215411,908976,958645,169665,440292,842576,117134,852142,983768,361440,847706,153141,406673,363280,335654,450054,1005657,490678,618508,572472,337985,394413,850480,938090,549875,366213,906006,587019,389542,989801,214355,1046085,754251,202260,111838,887134,229338,5574,382716,531122,64179,504000,486684,529868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]