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` = 498406 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498406 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50161,489349,683426,1005072,106642,716687,253462,792016,640297,800277,1668,286667,812837,3193,193527,196580,929761,215965,38699,887096,881085,381868,912434,661020,727450,193743,795763,1028428,773712,918232,457087,142512,1047417,142834,410062,618917,62004,279771,143122,919351,671897,829732,127234,974737,8595,133359,591040,733502,959772,924943,27284,692936,576110,327197,318942,738756,830068,466029,964871,325313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]