SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502741 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502741 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530399,691620,453653,351753,430687,508555,479752,396323,783037,863421,792176,362770,906087,462367,719827,291798,276457,243663,547667,795333,870451,124609,832191,915313,627471,895807,831648,181361,534691,514717,421249,36730,1016196,389114,378585,158582,724245,1043798,483612,568116,886220,509709,395137,170455,277253,369293,715651,164412,652251,885551,720914,753057,582420,740248,221919,1001465,138841,114802,947988,485377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]