SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591141 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591141 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438560,394561,170583,117663,677207,948277,554273,470325,385062,809622,150296,800649,765791,526105,683240,625002,375871,138391,684507,979173,372757,207932,871074,685123,548032,10883,101221,596653,483351,705416,844617,809287,1009183,56152,201043,422599,159686,1024444,529431,367856,733726,405302,44446,513012,267358,1044638,690842,966698,819169,468328,554891,741045,241920,811213,591412,535095,645587,371069,674506,836116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]