SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403626 LIMIT 1 [ RunTime:0.000940s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403626 [ RunTime:0.004828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199473,648620,193008,846423,559590,765531,945166,205127,969517,191459,260927,507603,943375,863161,549225,325736,105920,401218,535442,251452,186281,307394,119894,48430,494327,707085,766589,762870,233444,409275,598819,988176,901507,301153,915516,25726,811174,921060,564221,971617,820584,529376,1029070,1037343,433565,448534,966533,539760,617054,630410,922592,650902,189297,20752,742197,954768,455300,28258,1027005,753747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]