SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 911571 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 911571 [ RunTime:0.005150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592515,327641,446883,342071,367848,966459,460089,658066,171671,501916,662082,579416,583319,636495,454175,112913,592073,439796,122276,224057,491004,324587,741842,486360,1016483,400396,772968,995595,657934,709903,203910,683927,377753,310659,488399,478475,426347,122995,785667,172838,985460,636396,105369,466072,466873,300666,10577,843600,893244,597253,823753,664875,589419,312855,427577,103096,759678,272711,905780,954754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 911571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 911571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]