SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181716 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181716 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400308,80034,1030107,748434,329881,948100,303198,435192,907146,673190,507761,386109,319738,19033,621541,280108,505383,197981,489196,10180,913018,287826,872669,550881,431700,421048,739411,785712,410351,430528,786855,528868,446347,44434,168425,304881,445709,520676,224241,443642,894004,800739,656078,444569,422385,115323,736405,80638,160698,492657,115313,331257,851421,790719,411996,311688,560907,18153,400178,821886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]