SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505020 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505020 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451842,591906,442615,831798,346190,344607,153859,199838,511099,61203,975818,881445,285669,219214,186873,417838,709420,530153,186956,996889,202725,115791,385433,59719,251143,53307,945305,846441,747726,306732,612638,401704,699540,962289,840603,808064,707284,918735,848991,470608,380768,629193,3957,280078,736768,849232,691203,387163,826905,750907,729021,643812,776664,979788,417153,506272,1038497,688718,306191,105735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]