SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 912850 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 912850 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248155,510096,648061,978963,100800,181403,201083,644339,500659,571560,885321,844386,342,425727,990820,373090,801364,280046,599104,877639,493263,666151,42843,893467,923418,775637,345094,645470,668095,580063,953903,964685,415577,171461,605054,136538,946268,229422,910204,163194,896995,268348,153811,995120,861462,978311,700578,1023649,597001,70792,353603,1004276,712070,688785,224200,585980,21026,233312,175862,329527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 912850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 912850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001594s ]