SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540889 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540889 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347213,248179,220021,661910,57385,113550,193180,589265,877372,167689,832771,365446,153882,558118,173971,512897,733087,426112,393710,1001122,406243,927614,272789,48126,972796,97934,551574,692243,744095,32482,874650,522248,486253,951038,383897,76034,168422,732740,1024352,690310,572522,1025525,268485,969966,238359,1045478,43421,480707,1042070,533949,1005542,778608,825867,704470,261015,591242,28465,340943,100013,17987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]