SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 630413 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 630413 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046418,865179,255188,381731,387222,1035594,6851,453774,451525,753467,729026,53695,475120,1042651,652452,541322,264646,436558,304821,964354,795718,906277,72123,375927,468749,944294,80158,372850,397434,146997,743086,396241,593498,702943,684376,980463,556613,519974,1010698,154183,794541,292759,559887,201398,599603,947553,707925,835439,913068,31199,641225,997672,709196,146203,328807,448638,303475,555667,735658,386968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 630413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 630413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]