SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386470 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386470 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363585,989277,875928,515798,465352,212535,247032,1013599,819883,490970,881268,778249,974270,419296,864161,176707,415494,154890,257414,239684,401961,328902,852019,807850,905646,780570,481959,444135,732181,527199,761013,911722,51940,150322,1039944,420581,60915,535386,637483,618126,547322,704483,244124,332088,95992,915062,795374,116900,838836,315048,271035,949003,686,343089,692118,133360,750340,110029,945966,165179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]