SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 168104 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 168104 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596215,730022,979793,548326,513366,1146,748357,727828,339470,415307,3820,449251,387939,708970,367489,644565,222034,80582,216689,146364,884924,574337,268556,483437,392220,487675,36557,228612,848336,331673,672961,201695,335796,982292,847682,925981,769530,92843,411037,46790,844137,781719,230006,219132,438727,492710,568397,621537,61208,36944,388622,588992,105197,385879,360996,195724,111828,217602,740728,442389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 168104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 168104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]