SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 65018 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 65018 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188794,891091,546387,721590,353191,884326,430135,110078,511450,153547,111451,470389,300320,347995,422638,411310,716549,345779,819726,857048,291732,251373,521339,29866,799919,273383,873833,990475,881658,757914,361284,447548,822873,546706,703484,864204,778454,416113,150459,480513,212113,917896,142643,525197,881116,297776,158340,495021,185427,437483,1020222,42747,382886,584108,554314,625048,894573,83285,334567,119000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 65018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 65018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001499s ]