SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565352 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565352 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70501,803529,60914,10886,626088,677999,401314,994675,249675,908127,1018311,308265,65525,754374,23653,417326,712983,589864,636193,144753,273123,812502,744210,881873,842870,908400,139999,533341,1036705,1014449,610309,909552,586380,256434,191357,938348,947200,190075,851413,622871,729086,466132,548005,754799,799625,346878,148075,216826,603713,544288,680416,210674,572087,101280,166950,758038,957167,22980,462452,978794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]