SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585445 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585445 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273109,815031,697245,869036,259623,148745,326055,811843,767945,94095,23023,7830,15466,730240,449424,243671,977470,1016360,645866,718416,378235,415811,573734,650462,701609,891262,750128,549435,474606,567810,988765,353853,327985,303128,884423,496088,3081,95958,362568,166430,908128,87603,803746,470174,120583,99242,589765,756834,894386,724352,1001864,918575,118124,402069,572988,661011,107670,842942,776279,524664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]