SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180181 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180181 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78653,65183,643361,992776,871168,257476,498115,29618,661292,263834,792216,457036,687426,298187,794543,628123,111549,221030,756719,32387,533729,236724,863063,954113,90800,879930,129882,762694,802635,874722,375363,991871,368441,865827,414679,2876,594265,597334,409036,954360,286009,448360,108652,971404,407629,435644,302769,701286,896007,470646,580169,1025654,900757,715378,515887,345465,926357,321236,848325,502424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]