SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419529 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419529 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564292,17410,1000027,618614,906072,128786,477521,1020792,765212,1016326,432535,119177,407691,925123,262565,493505,1003436,96368,660006,377642,804581,92248,778604,127885,351649,835607,787486,148130,178657,160842,435864,238632,753758,1027684,907944,71640,278559,416053,854827,86781,727628,818938,117067,850895,214121,166710,569968,527971,425318,87188,371845,946352,218038,319554,353935,438271,182658,1003449,587579,636510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]