SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434422 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434422 [ RunTime:0.002946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630037,559176,336449,447525,577587,672762,976038,719783,322666,37875,394884,804029,745367,317709,94173,597245,839058,186350,1013648,121658,455273,234281,44589,572451,956609,378891,531746,759760,525112,796772,176639,268768,1032318,15346,34735,303099,85314,505092,266822,758335,852023,471436,748621,265352,7800,420604,732781,346129,1010230,44327,248801,96647,634676,467380,713248,837447,472927,629203,48754,317490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]