SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504077 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504077 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900104,997564,916835,112073,749813,50138,487181,69812,418697,473215,883954,38560,612102,47886,300376,520314,864893,793758,28761,433139,321979,428024,62433,901219,780048,652146,840934,276910,875603,885887,429754,455072,657023,360328,1034836,349274,229143,283188,100592,439897,810777,627292,716766,740454,272882,312457,589585,679947,22113,915714,424261,677260,539884,187339,981885,800166,950815,194088,647110,554864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]