SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53104 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53104 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442140,171957,313475,146172,290936,771232,816386,664812,703943,215215,581020,631623,787823,293516,429478,223959,771197,1048374,723888,954130,702859,67209,519621,602034,690394,881538,193016,879027,705481,193465,364501,408522,934310,539879,383629,988200,864472,36303,686616,361408,591934,508789,80950,911099,285404,692863,901280,124995,686692,324488,878263,196742,56991,932166,988678,33971,314824,469126,757454,51283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]