SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019518 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019518 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799453,238383,935364,587871,627035,264194,944145,651004,969949,580625,447493,634734,424477,679836,684005,698240,381793,146431,613919,170510,579101,58162,402720,807932,878485,687436,383826,230975,363874,270874,684251,914713,887060,996285,53036,721037,832441,70496,259403,133126,729055,151272,129888,260649,1014387,917037,40991,536797,969476,442319,32622,789448,268976,233514,584324,883194,887614,771699,375598,867074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]