SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171814 LIMIT 1 [ RunTime:0.001179s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171814 [ RunTime:0.002230s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608540,485223,870557,849507,237921,1034174,823956,380190,1025119,192527,876528,106475,255134,123689,332337,692413,395719,651885,674684,822841,424338,948631,594491,378584,91843,564010,168980,47066,731861,743011,227459,645825,349368,117636,666040,708672,330644,370818,1028184,707739,556374,121745,832299,452025,526744,291601,31774,212014,447460,424296,295550,693838,724897,776026,1010319,363777,188648,657744,478376,736753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]