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` = 391403 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391403 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715980,933118,59854,529013,761529,235178,358669,708263,143511,673380,405276,26653,448595,275992,870804,465542,252675,765304,579942,1037442,673028,544749,760638,585021,1000686,263507,304205,589725,158077,817986,1008139,200394,631680,355074,679216,218331,867195,297292,664130,752904,256067,318954,1013858,399014,53146,347837,724505,383988,146078,979644,153425,539010,235957,761074,123144,128593,618571,837625,220734,195124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]