SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019557 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019557 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40875,985403,607458,796507,22816,479562,975803,488981,864158,944009,471211,345037,11358,347324,85161,483223,649837,366215,258696,12601,701731,265423,66868,178221,504903,853238,233330,849168,375289,280528,582828,934193,353594,411213,235899,862954,605792,918624,807164,191570,773731,176904,85564,1020688,658836,451172,1015172,524195,1026018,585665,2660,504028,737204,434727,133976,304685,819240,694457,791697,716560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019557 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019557 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003062s ]