SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018794 LIMIT 1 [ RunTime:0.000771s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018794 [ RunTime:0.002353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298860,182249,921121,332656,698652,6954,703388,832028,663025,1035757,901576,336976,832699,553931,893491,550141,678812,735489,121911,744150,1046454,530089,689027,61131,302112,191043,909626,1004211,1031472,281944,546953,755924,367694,729916,967088,606411,953093,710698,937845,5455,923453,1032338,193154,402488,474834,669786,385048,13724,247165,53162,63518,52212,78869,968755,95297,978388,971297,320196,293206,249276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]