SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 908180 LIMIT 1 [ RunTime:0.000881s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 908180 [ RunTime:0.003063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529588,958080,174684,948448,263202,302613,367498,1022526,861172,82752,953111,634048,799078,619265,513626,497103,584768,562567,217239,1026354,658947,385900,29571,1024855,966432,517788,195849,119061,331285,43724,1012882,860428,553541,355987,39939,318731,227433,1025765,592066,267730,866327,68115,1009017,967373,748850,239094,987760,215869,96668,86830,1042043,330175,912394,677503,95153,865157,1026418,49575,334552,86708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 908180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 908180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000867s ]