SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524401 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524401 [ RunTime:0.003161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419331,252451,262712,428563,633085,420963,733323,738075,832863,561693,658733,782386,318708,824193,1045982,574633,244548,894782,175141,808675,622135,735604,855666,135057,821435,385062,187938,629309,572691,84712,879648,5527,332030,709503,707358,671878,98150,179827,338078,864393,94268,667309,298576,543407,667504,764330,964956,889540,213304,168692,581412,1017309,129958,456770,715906,260588,988753,965154,979824,251529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]