SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014499 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014499 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492281,660090,816135,614209,869729,93274,767240,446416,439087,622227,384799,901604,493656,674054,954099,71650,112396,147977,871312,1040092,391531,346126,1045583,501251,391512,775259,570958,1029794,751189,518145,576951,904521,688959,913003,842296,625298,1026458,186056,670438,965869,596017,732304,551265,534049,604479,628440,654255,847124,474750,818875,275064,752865,167403,274491,572786,109707,463058,488516,1013748,685224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]