SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479943 LIMIT 1 [ RunTime:0.004983s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479943 [ RunTime:0.006426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641956,860598,503807,641909,452143,404876,497391,1843,913567,836613,330448,1016893,656250,663907,416472,389971,818337,565030,442702,438111,109109,858486,159763,173419,985597,635447,1036165,1002595,956894,103192,1044586,99025,457299,201097,90735,692179,133772,12541,535661,227326,696843,450970,724748,394162,323190,115782,144639,745972,693120,964996,214397,785450,588924,918085,208302,524738,308711,203166,731004,664273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000902s ]