SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041668 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041668 [ RunTime:0.003699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989882,196386,77621,848862,21130,324192,70658,10248,34373,529730,342987,182559,165775,945955,932093,310241,340214,1040588,627598,339486,502935,770886,54230,189133,50168,652690,611358,962180,650387,1022987,952402,908771,511362,308664,1039026,52791,303804,645677,25282,70836,518646,109705,279083,472917,544693,135363,256550,789347,119787,804860,270797,662811,584871,572707,174696,769142,918219,101438,932271,52655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]