SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004438 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004438 [ RunTime:0.003968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796338,647073,445253,481577,226738,690578,361689,512946,599165,827850,468618,615198,594945,729839,452601,287043,955416,863624,48515,508787,610924,788896,41834,328857,788503,648285,514610,809608,895963,674849,743275,599610,854769,108274,550361,522698,544842,11484,940390,756211,260953,953975,118631,821533,794532,304107,253611,229304,20084,930841,602376,832549,1045565,229825,535502,17441,934624,848571,762395,378963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]