SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991599 LIMIT 1 [ RunTime:0.001555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991599 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005393,343957,33101,301498,343949,442634,766621,185509,465168,484006,957044,316036,848520,687566,1046758,416564,791575,1026555,344730,802672,578190,47843,420050,1007014,15283,960345,395503,618569,830642,935102,409654,678777,220513,842531,1035655,13767,131180,363982,1027570,575120,337543,943135,643105,553604,481360,211327,841751,983525,916367,342675,771271,936241,909666,487625,1036742,403043,683508,138879,1034021,571081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]