SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405239 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405239 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767940,326075,688236,142281,935166,873708,1048659,988920,748237,707746,426859,320362,559288,507146,971170,626987,359097,684718,960776,796021,249039,255239,785478,894054,315413,400853,210925,980081,510925,859882,701434,732047,341319,332831,808227,133279,851327,741493,765971,543088,86778,988990,246613,149470,581391,767733,855035,1035373,587241,222011,397478,1023868,537642,826187,404378,917904,453303,1015267,676210,800386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000909s ]