SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251021 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251021 [ RunTime:0.003520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816205,1044916,1017232,731590,481846,960853,662058,599107,625019,726147,662042,189709,529952,732786,59938,723651,705527,166240,155883,1040762,220438,361651,356431,514504,765204,698126,744460,155743,65793,1042909,254865,381233,76537,680228,127969,525079,526531,708817,719120,672070,445021,708786,220302,783948,962790,547344,602345,470773,1005887,837195,486104,184567,122980,482016,948885,948684,525760,960373,896789,266646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]