SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200519 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200519 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100205,319058,472278,497085,195819,890886,267324,12443,1005808,553923,301625,183677,716930,78575,369881,808013,91395,434449,468093,932363,340520,6496,104352,758502,12216,1348,432336,273529,710818,700116,292794,274310,180957,406610,906929,945235,419711,546423,651151,768034,30423,713958,680391,669991,862772,312134,689496,943808,889802,769478,572919,970623,874194,276706,715873,526645,959773,931980,734759,258728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]