SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30688 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30688 [ RunTime:0.002373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595106,131871,856389,298023,562056,131868,395383,402060,607128,423364,394347,537433,334223,157653,14620,1047132,80406,786668,613957,186323,578982,506433,281306,505067,555601,435767,326755,519709,1046767,1040055,732486,352762,61490,726142,725518,756626,982477,296959,365644,187944,439903,846484,926493,594681,329035,457361,604851,82154,877598,57902,781986,549618,45390,157193,295068,87174,861015,120253,883515,613231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001394s ]