SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498128 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498128 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51447,383907,337213,746818,997755,236814,945095,24102,401588,453754,966700,129190,247097,210258,1035716,263025,592880,863184,600065,713017,674462,1043520,213286,782995,732793,185033,327342,914896,964882,838564,371510,718406,623483,739888,271591,771484,296962,355209,56000,375829,107761,386842,172231,254798,417956,165230,331706,681873,778221,792500,63896,304156,529042,414257,139180,456946,607551,841648,979446,247606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]