SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283654 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283654 [ RunTime:0.004520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149344,724593,700960,877897,267521,1048111,705169,862526,148199,1003841,473009,259587,748418,615604,566927,125639,314721,12041,75704,881845,921702,167308,780897,752161,95681,763571,940357,478180,227947,957430,61656,933286,218147,592507,14788,377724,229135,521257,228919,425868,115159,421074,69011,107829,1031867,27934,744546,237632,848414,6976,245639,472442,826957,867187,361095,894898,251967,986326,264798,638629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]