SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631900 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631900 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809584,533342,258143,758341,802454,615349,840612,837948,828577,726838,514378,17914,913080,105532,431132,485737,699860,93292,317734,401820,50280,818555,664205,808312,330184,457137,958024,819216,391258,401090,1024875,1047132,1041453,270403,149291,90543,146258,979851,728680,568715,149383,373602,421107,870867,300636,912008,297335,606139,505295,348362,330157,1037009,1030722,390601,198648,166524,631950,89818,213601,1021743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]