SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029855 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029855 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (870031,57854,366465,591424,124911,256770,730092,850541,259214,156768,82359,954649,802807,210309,981875,363847,171688,719337,395744,489405,13729,985684,227332,849045,204236,820473,763522,402398,484362,463538,398369,227905,610761,803224,1015794,167272,302040,41259,493504,895978,615784,317557,142626,508708,904894,620155,24405,505546,340428,532712,180508,451748,523066,460061,425553,889116,821702,8381,71783,389683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029855 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029855 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]