SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401618 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401618 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760857,324816,508442,1006185,391014,100269,988693,825940,767304,398535,746276,807523,888914,508795,144007,43330,990466,674096,587242,772738,663980,1029078,681847,841142,765858,36242,50564,988110,471510,679494,920149,960101,928,64352,491942,208171,104292,759278,670693,513079,821233,92822,554696,562412,914581,937195,713407,345145,29174,1021156,112680,983924,296115,795600,809246,212551,16369,732052,423403,599663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]