SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10518 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10518 [ RunTime:0.004852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50443,291596,716398,239839,386255,817677,315202,505963,140311,201265,822648,912704,599107,244106,86852,1017667,444055,975746,23435,447650,1035248,849610,775817,623025,922316,985729,172182,394607,862004,977275,309493,172140,343386,106720,519308,424181,768518,672724,749480,898831,788910,277262,90521,207491,250973,662730,124035,794739,653833,297950,275506,140882,988916,747435,882961,69889,304679,598243,591777,920172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]