SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404304 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404304 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455916,475842,525799,153230,834321,638231,610038,811831,883455,208162,591344,778563,330974,32592,197392,102125,678954,717428,309033,273791,788660,580125,218491,186518,629459,745622,976400,391526,973848,315389,738447,980839,18471,1029374,766100,772556,861001,350193,33140,686625,99168,648796,363869,170024,684913,783765,238470,63652,906651,389275,705430,683603,451970,482359,586272,967677,365088,657882,825202,990807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]