SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048905 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048905 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427851,922047,922312,613814,705080,244092,312433,604335,1025342,963420,529377,527081,659801,464323,171114,450369,634564,867345,75035,994403,350762,576665,1042044,872824,880727,813847,318682,979783,814322,733217,99037,112835,643976,199071,264644,281259,685837,720037,877974,334679,764375,554076,565659,931849,242415,835511,651819,58306,767428,610139,1002807,26273,21950,597858,611680,968189,930254,450195,389626,703411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]