SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525093 LIMIT 1 [ RunTime:0.000899s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525093 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133034,829672,1039351,249341,482811,388198,197493,197474,552385,79231,107857,824280,11307,299738,561120,95600,284192,19570,133950,977973,636512,1019125,166135,121509,608347,700405,895367,604234,37081,345140,51907,1019379,624495,32936,978899,146398,779679,894374,657627,289895,474533,873379,517265,558334,963928,465718,948634,192723,768610,724610,528901,840420,179783,170252,870174,343558,875980,370277,132345,365160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]