SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503347 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503347 [ RunTime:0.006150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729001,629258,220800,387135,707230,739606,324936,499630,173166,135839,837033,296559,1010032,969949,587323,764956,579862,217275,491086,396746,115294,497076,98716,267131,981086,180377,559705,627704,784830,569528,158716,130072,281517,723210,812346,145655,76496,105629,671088,381588,782743,48497,929072,952507,346743,800818,281902,917058,543227,615887,53233,137584,609725,436078,363960,482543,608748,33104,995295,591621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503347 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503347 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002735s ]