SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405952 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405952 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652192,1007927,211227,697665,678611,976585,314973,700223,489030,472951,401906,122083,622273,841528,360483,935032,808812,928278,94542,948154,530042,807164,692818,979833,310010,723803,28819,63335,239044,263275,796529,640298,149502,609230,873305,946300,809566,750222,752665,116655,399506,928097,975892,349456,394769,1045704,352172,159180,69605,225827,794277,312522,805796,56070,647200,930945,325064,504405,283440,474305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]